const express = require("express");
const app = express();
const port =8080;

const users =[{uesrname:'admin',password:'password123'},{
    uesrname:'admin2',password:'1234'
}]
app.get("/login",(req,res)=>{
   conn.connect((err)=>{
    if (err){
        console.error("1."+err.message);
    }else{
        console.log("1.连接成功");
    }
   });
   let sql = "select * from user where username ='" +req.query.uname+"'and password='"+ req.query.upwd +"';";
   conn.query(sql,(err,result)=>{
    if (err){
        console.error("2."+err.message);
    }else{
        console.log(result)
        if (result.length>0){
            res.json({code:200,msg:"登陆成功"});
        }else{
            res.json({code:401,msg:"用户名或者密码错误"})
        }
    }
   })
});
app.listen(port,()=>{
    console.log("监听端口"+port);
});